UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9l5vXs4UCSaKiIDrXz0JRCuttGODqrIjxd4rzKBukYU='
WHERE
key_id = 'd4859e1762e0d790b33fe128bf5e36667106c3a9d0025748dcf88bf0526af4c9'
AND (
token = '9l5vXs4UCSaKiIDrXz0JRCuttGODqrIjxd4rzKBukYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)