UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'VdTErA3fMlYV1u0JnVG3+/aFDzY9bZ/A7AJtFbCCpL8=' 
WHERE 
  key_id = 'acc4fa77095a249461a32f5a23b56bd2a482ee8c4c7d62a6855732c1fa47914e' 
  AND (
    token = 'VdTErA3fMlYV1u0JnVG3+/aFDzY9bZ/A7AJtFbCCpL8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040