UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yNE9GwmA6PKKYk8CM6cnIUd8PIgMkT3GGk1EC8n2m88='
WHERE
key_id = '414f81451c8e572fa036f51d11c4eb9f64b10c5ace65d5ce0228952ce1672bef'
AND (
token = 'yNE9GwmA6PKKYk8CM6cnIUd8PIgMkT3GGk1EC8n2m88='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)