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