UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JcMQslnaeh+Nmb2o901sWy/kNtAP6aNkoPRUf6SN5X8='
WHERE
key_id = 'b5397cd9320134b5fac52ddb5295552eb4617a5afa1638102dce44647818cdb8'
AND (
token = 'JcMQslnaeh+Nmb2o901sWy/kNtAP6aNkoPRUf6SN5X8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)