UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CWVsvcLX7IGtNb5nfHn6jegYYhpOObNhb5AFknsQs04='
WHERE
key_id = '42303959179fcddc102999700524eeb2ff2d6bb2b31040862796dce629efbaa0'
AND (
token = 'CWVsvcLX7IGtNb5nfHn6jegYYhpOObNhb5AFknsQs04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)