UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p/hx4gtePG11hMKQN8uuw4x+AiLENvxMDYBGE+G7QIQ='
WHERE
key_id = 'debc29953956b6fa1c67b09d5d7b635aaf6f00426ceb26bae69f8eb3d748728d'
AND (
token = 'p/hx4gtePG11hMKQN8uuw4x+AiLENvxMDYBGE+G7QIQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)