UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XQinIy6xqLE+yPEYGMOht0LRxNOg7mbAH74HqXLUWh0='
WHERE
key_id = '5115b52a3227a613397372d37b2e3667720f0fd853fe7e9c5077440c9627b640'
AND (
token = 'XQinIy6xqLE+yPEYGMOht0LRxNOg7mbAH74HqXLUWh0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)