UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W7fpRMugSgBvgmxeMT+bossuXaFbejli+9VJT1ZM+3I='
WHERE
key_id = '2b919ca3dbd33fe58c7716f9d42435b25034f03e49839216f5b5f120b47eff57'
AND (
token = 'W7fpRMugSgBvgmxeMT+bossuXaFbejli+9VJT1ZM+3I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)