UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TH7e7O5wXcf3NB75BQkGTOmoSPKQ1cHTAynLrwNYFUw='
WHERE
key_id = '76c383829a71e4e75291bc53683a48578da8840900e745e212e699d721ac434d'
AND (
token = 'TH7e7O5wXcf3NB75BQkGTOmoSPKQ1cHTAynLrwNYFUw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)