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