UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aBmftoyp1Fk5zFREK81qsKJ1fwWcPnDF7qLknX+GgAg='
WHERE
key_id = 'd00565a4b4f92ec51bf7d2367673f382a7f510b01e496767fd18a017080eec7d'
AND (
token = 'aBmftoyp1Fk5zFREK81qsKJ1fwWcPnDF7qLknX+GgAg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)