UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sWL367oGVvyPECeMABL3ZwlkW14E9viRE7rdn0PUEV0='
WHERE
key_id = 'ee4516c8a5afc2cfd46e689d073f9a8aba2086a4463073ae9f11e02b7f006d4e'
AND (
token = 'sWL367oGVvyPECeMABL3ZwlkW14E9viRE7rdn0PUEV0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)