UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z8Ad7a5O0JJkBiG4g2ubggNdnQSpWyi3kQghfNNHTRk='
WHERE
key_id = '97c943dd0a933627ca0c3e43e20c18de3f217846d5fc8f3fc222ce1ab8d78a49'
AND (
token = 'z8Ad7a5O0JJkBiG4g2ubggNdnQSpWyi3kQghfNNHTRk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)