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