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