UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WrNR2SJ+7eyhvJ8oFiPmuMgF2Pq7ovT0UfyIOZK77Zg='
WHERE
key_id = 'c1d5714d36ddc0106f056d830cc36f05f160c2341daf90694d1b0e46c9defdc5'
AND (
token = 'WrNR2SJ+7eyhvJ8oFiPmuMgF2Pq7ovT0UfyIOZK77Zg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)