UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XY5O0YVc1qLosjUrctBwB1FTOsR51fXhxqlN/TNZcaU='
WHERE
key_id = '0e565e37ee5d262def5c1c10bcb6391a564e9c39e365ad2680a1f48536b07dca'
AND (
token = 'XY5O0YVc1qLosjUrctBwB1FTOsR51fXhxqlN/TNZcaU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)