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