UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pry/d4j7BcZvXRIlTMRyD74iw9YWt5VMdvsTrXyuZxo='
WHERE
key_id = 'dc8063f0ac29285213e08865b0e47162fce0d9a8ae596c9dab0c2c7d70b5adc0'
AND (
token = 'pry/d4j7BcZvXRIlTMRyD74iw9YWt5VMdvsTrXyuZxo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)