UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IpH0uDTyIN7YYdO0+YiT9bmbkSq/vVOe3bJ6Y9PZ0EA='
WHERE
key_id = '56f2af0ebf551a6b5c001ec7bb35a7b4dc2a0cc93610fbdf69600995e9b9ec06'
AND (
token = 'IpH0uDTyIN7YYdO0+YiT9bmbkSq/vVOe3bJ6Y9PZ0EA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)