UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NGHoTibtYmmqlzI1Wa9a0BzhfoBiXVo0R+4U19E9jv0='
WHERE
key_id = '34d9468cd28d3ee847a712de5f85e086b0fcabb099ddf87d72e365624041099c'
AND (
token = 'NGHoTibtYmmqlzI1Wa9a0BzhfoBiXVo0R+4U19E9jv0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)