UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NN0FXkP2+xqiAJJKP8zb3V9KBObPpUYJMQDvKJoA+jY='
WHERE
key_id = 'b4eec1febeeae219bd43511676442ea9c6003d1c4bfa99c1caccc686a3e1216f'
AND (
token = 'NN0FXkP2+xqiAJJKP8zb3V9KBObPpUYJMQDvKJoA+jY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)