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