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